import excel "$raw/doctors.xlsx", sheet("Projekt_data") firstrow clear

keep municipality_id state population gps_other gps_ogk gps_wahl gps 

lab var gps_other "GPs - other insurer"
lab var gps_ogk "GPs - OGK"
lab var gps_wahl "GPs - Wahlarzt"
lab var gps "Number of GPs"

encode state, gen(sh)
drop state
rename sh state

save "$edited/doctors.dta", replace
